ALTER PROCEDURE [dbo].[Delete_scenario] @file_No INT 
AS 
  BEGIN 
      EXEC dbo.Delete_results 
        @file_no; 

      DELETE FROM dbo.dvip_in_bodyweight_open 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_cull_risk_lact 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_cull_risk_mim 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_cull_seasonality 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_milk_seasonality 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_milk_wood_curve 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_misc 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_price 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_repro_abort_risk_mpreg 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_repro_conc_pct_mim 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_repro_conc_risk_lact 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_repro_conc_seasonality 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_repro_heat_pct_mim 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_repro_heat_seasonality 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_in_repro_misc 
      WHERE  file_no = @file_No; 

      DELETE FROM dbo.dvip_sys_files 
      WHERE  file_no = @file_No; 
  END 